package com.jy.wms.dao;


import com.jy.wms.common.base.BaseDao;
import com.jy.wms.pojo.WmsStatisticalWeight;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * Created by Administrator on 2018/5/8.
 */
public interface WmsStatisticalWeightMapper extends BaseDao<WmsStatisticalWeight> {

    /**
     * 分页查询 取到省份
     * */
    public List<WmsStatisticalWeight> baseSelectPage(@Param("WmsStatisticalWeight") WmsStatisticalWeight entity);

    /**
     * 查询0-1KG含1各省的运输单数量
     * */
    public int oneNumber(@Param("sheng") String sheng);

    /**
     * 查询1-2KG含2各省的运输单数量
     * */
    public int twoNumber(@Param("sheng") String sheng);

    /**
     * 查询2-3KG含3各省的运输单数量
     * */
    public int threeNumber(@Param("sheng") String sheng);

    /**
     * 查询3以上各省的运输单数量
     * */
    public int fourNumber(@Param("sheng") String sheng);

    /**
     * 导出
     * */
    public List<WmsStatisticalWeight> exportStatisticalWeight(@Param("WmsStatisticalWeight") WmsStatisticalWeight entity);
}
